CREATE TYPE "pr_review_task" (
                              inbox_owner_id        string(38) (SET "label_text"='Inbox Owner ID'),
                              inbox_owner_ref       string(128) (SET "label_text"='Inbox Owner Ref'),
                              review_id             string(38) (SET "label_text"='Review ID'),  
                              review_title          string(128) (SET "label_text"='Review Title'),
                              review_status         string(128) (SET "label_text"='Review Status'),
                              due_date              time (SET "label_text"='Due Date'),
                              my_status             string(128) (SET "label_text"='My Status'),
                              review_owner          string(128) (SET "label_text"='Owner'),
                              workgroup_id          string(38) (SET "label_text"='Workgroup ID'),  
                              workgroup             string(128) (SET "label_text"='Workgroup'),
                              description           string(1024) (SET "label_text"='Description'), 
                              participants          string(128) REPEATING (SET "label_text"='Participants'),
                              participants_roles    string(128) REPEATING (SET "label_text"='Participants Role'),
                              participants_statuses string(128) REPEATING (SET "label_text"='Participants Status'),
                              deleted_review        boolean (SET "label_text"='Is Deleted'))
WITH SUPERTYPE "dm_sysobject" SET "label_text"='PleaseReview Review Task' PUBLISH


// PleaseReview 5.0.21 Changes
ALTER TYPE "pr_review_task" ADD (
                              parent_review_id      string(38) (SET "label_text"='Parent Review ID'),
                              compound_review        boolean (SET "label_text"='Is Compound'))
PUBLISH

UPDATE
 "pr_review_task" OBJECT
  SET "parent_review_id" = '-1',
  SET "compound_review" = FALSE


